Change Data Type#
Description:
Change the data type of one or many columns.
Function:
Data_Types(table = string, dtype_group = {col = string, dtype = string} and {col = string, dtype = string} ...)
Parameters:
Table: Table name on which to perform function
Column: Value to fill the column with
Data Type: Data type to change the column (string, integer, date)
Example:
Data_Types(table = Budget, dtype_group = {col = "Date", dtype = "String"} and {col = "Plan", dtype = "Integer" })
Date |
Geo |
Business |
Plan |
Actual |
|---|---|---|---|---|
5/1/2024 |
Latin America |
Energy |
900 |
900 |
5/1/2024 |
Latin America |
Manufacturing |
1050 |
1100 |
6/1/2024 |
Latin America |
Manufacturing |
2000 |
1800 |
Date |
Geo |
Business |
Plan |
Actual |
|---|---|---|---|---|
5/1/2024 |
Latin America |
Energy |
900 |
900 |
5/1/2024 |
Latin America |
Manufacturing |
1050 |
1100 |
6/1/2024 |
Latin America |
Manufacturing |
2000 |
1800 |